'use strict';

const conn = require('../../libs/Conn');

module.exports = async function (params) {

    let querySql = `SELECT
                        '全部' AS dataType,
                        '0' AS value
                    
                    UNION
                        SELECT
                            engineering_no AS dataType,
                            engineering_id AS value
                        FROM
                            engineering_file 
                        WHERE
                           delete_sign = 1`;
    let rec = await conn(querySql);
    return {success: true, data: rec};

};